package com.mantru.iotpot.dao;

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.net.wifi.WifiManager;
import android.os.Build;
import android.os.Environment;
import android.provider.Settings;
import android.telephony.TelephonyManager;
import android.text.TextUtils;

import androidx.annotation.Nullable;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Collection;
import java.util.Enumeration;
import java.util.Map;
import java.util.Properties;
import java.util.Set;

/**
 * 手动炒制里的喷泵配置表
 * 作者： cmh
 * 日期： 2025/03/13
 */

public class t_handing_config_nozzle
{
    public String table_name = "t_handing_config_nozzle";
    public String config_id, nozzle1_value, nozzle2_value, nozzle3_value, nozzle4_value, nozzle5_value, nozzle6_value, nozzle7_value, nozzle8_value, nozzle9_value, nozzle10_value, nozzle11_value;
    public String create_sql = "create table t_handing_config_nozzle(config_id integer primary key, nozzle1_value integer, nozzle2_value integer, nozzle3_value integer, nozzle4_value integer, nozzle5_value integer, nozzle6_value integer, nozzle7_value integer, nozzle8_value integer, nozzle9_value integer, nozzle10_value integer, nozzle11_value integer)";
    public String update_sql = "update t_handing_config_nozzle set nozzle1_value=?, nozzle2_value=?, nozzle3_value=?, nozzle4_value=?, nozzle5_value=?, nozzle6_value=?, nozzle7_value=?, nozzle8_value=?, nozzle9_value=?, nozzle10_value=?, nozzle11_value=? where config_id=?";
    public String entity_sql = "select * from t_handing_config_nozzle where config_id=?";
    public String list_sql = "select * from t_handing_config_nozzle order by config_id";
    public String drop_sql = "drop table t_handing_config_nozzle";


    public ContentValues GetInsertContentValues()
    {
        ContentValues cv = new ContentValues();
        cv.put("config_id", config_id);
        cv.put("nozzle1_value", nozzle1_value);
        cv.put("nozzle2_value", nozzle2_value);
        cv.put("nozzle3_value", nozzle3_value);
        cv.put("nozzle4_value", nozzle4_value);
        cv.put("nozzle5_value", nozzle5_value);
        cv.put("nozzle6_value", nozzle6_value);
        cv.put("nozzle7_value", nozzle7_value);
        cv.put("nozzle8_value", nozzle8_value);
        cv.put("nozzle9_value", nozzle9_value);
        cv.put("nozzle10_value", nozzle10_value);
        cv.put("nozzle11_value", nozzle11_value);
        return cv;
    }

    public String[] GetUpdateValues()
    {
        String[] values = new String[12];
        values[0] = nozzle1_value;
        values[1] = nozzle2_value;
        values[2] = nozzle3_value;
        values[3] = nozzle4_value;
        values[4] = nozzle5_value;
        values[5] = nozzle6_value;
        values[6] = nozzle7_value;
        values[7] = nozzle8_value;
        values[8] = nozzle9_value;
        values[9] = nozzle10_value;
        values[10] = nozzle11_value;
        values[11] = config_id;
        return values;
    }

    public String[] GetEntityValues()
    {
        String[] values = new String[1];
        values[0] = config_id;
        return values;
    }

}
